
CREATE TABLE `${tableName}` (

   `id` bigint(20) NOT NULL AUTO_INCREMENT,
   <#assign shortString="shortStr"> 
   <#assign mediumString="mediumStr"> 
   <#assign longString="longStr"> 
   <#assign datetime="dateTime"> 
   <#assign long="long"> 
   <#assign decimal="decimal"> 
 <#list props as map>
	<#list map?keys as name>
			<#if (map[name]==shortString)>
	 `${name}` varchar(50) NOT NULL,
			<#elseif (map[name]==mediumString)>
	 `${name}`  varchar(255) ,
			<#elseif (map[name]==longString)>
	 `${name}`  varchar(2000),
			<#elseif (map[name]==datetime)>
	 `${name}`  datetime ,
			<#elseif (map[name]==long)>
	 `${name}`  bigint(20) NOT NULL,
			<#elseif (map[name]==decimal)>
	 `${name}`  decimal(10,2) ,
			</#if>
    </#list>
 </#list>
   `add_time` datetime DEFAULT NULL,
   `add_user` bigint(20) DEFAULT NULL,
   `update_time` datetime DEFAULT NULL,
   `update_user` bigint(20) DEFAULT NULL,
   `isenabled` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0未提交，1已提交',
   `isdeleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0未删除，1已删除',
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8